Read Range

AutomatR.Excel.Activities.ReadRange

The "Read Range" activity in AutomatR is part of the Excel activities package, designed to read the values of an Excel range and store them in a DataTable variable. This activity facilitates data extraction from specified Excel ranges, enhancing automation workflows that involve Excel data manipulation.

Properties

Name	Description
Input
Header	When enabled, considers the first row as a header in the mentioned range of cells. Boolean variables indicating whether the first row should be treated as a header.
Range	Enter the range to read and use it for further operations. String variables containing the range in Excel format (e.g., "A1:B10").
Misc
Display Name	The display name of the activity. A display name is automatically generated when you indicate a target.
Optional
Delay	Enter the wait time in seconds (Example: 5 seconds i.e., 5) to start the activity. Integer variables containing the delay duration.
Output
Result	Stores the data extracted from the specified range in a DataTable variable. DataTable variables to store the extracted data.

How to use:

1. Drag and drop the "Read Range" activity onto the workflow.
2. Configure the properties by specifying the range to read and whether the first row should be treated as a header.
3. Optionally, configure the delay.
4. Execute the workflow to read values from the specified Excel range and store them in a DataTable variable.

Example: Consider an example where the "Read Range" activity is used to read values from the range "A1:B10" in an Excel worksheet:

Read Range:
  Range: "A1:B10"
  Header: true
  Result: ExcelData

In this example, the activity reads values from the specified range, considering the first row as headers. The result, representing the data from the range, is stored in the DataTable variable "ExcelData" for further handling in the workflow.

Note: Ensure that the "Read Range" activity is placed within an "Excel Root" activity to establish the Excel context for execution.